package com.wj.mybatis.mapper;
import com.wj.mybatis.model.UserInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import java.util.List;
@Mapper
public interface UserInfoMapper {
    @Select("select * from userinfo where id = 1")
    List<UserInfo> queryUserList();

    @Select("select * from userinfo where id = #{userId}")
    UserInfo queryUserInfo(Integer userId);

    @Select("select * from userinfo where id = #{id} and delete_flag=#{deleteFLag}")
    UserInfo queryUserInfoParam(@Param("id") Integer userId, @Param("deleteFLag") Integer deleteFlag);
}